package com.rg1906.service.impl;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;

import com.rg1906.dao.Impl.InsertStudentMessageDaoImpl;
import com.rg1906.entity.QueryClazz;
import com.rg1906.entity.QueryGrade;

public class InsertStudentMessageServiceImpl {
	InsertStudentMessageDaoImpl dao=new InsertStudentMessageDaoImpl();
	//查找最大学号   便于拼接
	public String getMaxNum(String gid, String cid) throws SQLException {
		return dao.getMaxNum(gid,cid);
	}
	//查找gid
	public int getGid(String gid) throws SQLException {
		return dao.getGid(gid);
	}
	//查找cid
	public int getCid(String cid) throws SQLException {
		return dao.getCid(cid);
	}
	//查找年级
	public List<QueryGrade> QueryNianji() throws SQLException {
		List<QueryGrade> list = dao.QueryNianji();
		return list;
		
	}
	public int queryClazz(String gid1) throws SQLException {
		return dao.queryClazz(gid1);
		
	}
	public List<QueryClazz> queryClazzs(int gradeID) throws SQLException {
		return dao.queryClazzs(gradeID);
		
	}
	public int insertStudent(String realname, int gradeCid, int gradeGid, String sNum, String phone, String address,String sex, String age) throws SQLException {
		return dao.insertStudent(realname,gradeCid,gradeGid,sNum,phone,address,sex,age);
		
	}
	public int insertUser(String sNum, String img) throws SQLException {
	return 	dao.insertUser(sNum,img);
		
	}
	public int getUserId(String sNum) throws SQLException {
		return dao.getUserId(sNum);
		
	}
	public int InsertStudentUid(int userId, String realname) throws SQLException {
		return dao.InsertStudentUid(userId,realname);
		
	}
	public int insertTScore(String sNum) throws SQLException {
		int i = dao.insertTScore(sNum);
		return i;
	}
}
